package com.example.demo.mapper;

import cn.hutool.db.sql.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.example.demo.entity.Bom;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface BomMapper extends BaseMapper<Bom> {
    @Select("select * from dbo.BOM")
    List<Bom> getAll();


//    @Select({ "call ${DM_SCHEMA}.p_dmk_fsyx(#{v_month,mode=IN,jdbcType=VARCHAR},"
//            + "#{v_type,mode=IN,jdbcType=VARCHAR},#{result,mode=OUT,jdbcType=INTEGER})"
//    })
//    @Options(statementType=StatementType.CALLABLE)
//    void callProcedure(@Param("v_month") String v_month,
//                       @Param("v_type") String v_type,
//                       @Param("DM_SCHEMA") String DM_SCHEMA
//    );
}
